MERGE JOIN OUTER
Short Description
Merge join operation to perform an outer join statement.
Where to use​
MERGE JOIN OUTER returns rows from row source B where row source A has matching rows. OUTER joins are driven by the right hand table. Resulting rows are fed to the next step in the plan.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.